/*
 * @Author: wangyingjie
 * @Date: 2021-08-18 14:57:04
 * @Email: wyj@hyrctec.com
 * @LastEditors: wangyingjie
 * @LastEditTime: 2021-08-25 10:26:41
 * @Company: hyrc
 * @FilePath: \TaskErrorManageApi\database\Dao\ProjectProblem\projectProblem_sql.js
 * @Description:
 */
module.exports = {
  QueryProject: "SELECT * FROM probleminfo WHERE ProjectId = ?;",//查询问题详情页数据
  DeleteProject: "DELETE FROM probleminfo WHERE ProjectId = ?;",//删除问题
  Querymanageinfo: "SELECT * FROM projectmanageinfo; ",//查询项目
  Queryremarkinfo: "SELECT * FROM problemremarkinfo WHERE ProjectId = ?;",//查询问题详情
  UPDATEProject: "UPDATE probleminfo SET State=?,Priority=?,BadLevel=?,BreakDownRate=?,BugCounts=?,OverProssece=?,IsPublish=? WHERE Id =?",//修改详情页数据
  AddProject: "INSERT INTO probleminfo (Id, ProjectId, Follow, State, Priority, Subject,AssigneUserID,CreateUserID,CreateDate,UpdateDate,BugCounts,BadLevel,BreakDownRate,StartTime,EndTime,OverProssece,IsPublish) VALUES (?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?,?,?,?,?,?);",
}